﻿CREATE TYPE [flcr].[DEVICE_PROPERTY_TYPE_UDT] AS  TABLE (
    [DEVICE_PROPERTY_TYPE_ID] INT           NULL,
    [AUDIT_USER]              VARCHAR (50)  NULL,
    [AUDIT_DTTM]              DATETIME      NULL,
    [AUDIT_DTTM_TZ]           INT           NULL,
    [AUDIT_MOD_USER]          VARCHAR (50)  NULL,
    [AUDIT_MOD_DTTM]          DATETIME      NULL,
    [AUDIT_MOD_DTTM_TZ]       INT           NULL,
    [BUILTIN]                 BIT           NULL,
    [ACTIVE_FLG]              BIT           NULL,
    [SORT_ORDER]              INT           NULL,
    [DEVICE_PROP_TYPE]        INT           NULL,
    [DEVICE_PROP_TYPE_NAME]   VARCHAR (100) NULL,
    [DEVICE_PROP_TYPE_DESC]   VARCHAR (250) NULL,
    [DEVICE_TYPE]             INT           NULL,
    [PARENT_ID]               INT           NULL);

